-
Re: Populating a dropdown list (Single select)
There isn't a way to have the value from one column change what values are in a dropdown picklist. There are ways to use formulas to put in all the names from the team into that column based on what …1 · -
Re: How to count Status using Multi-select Drop-down list as input values
You could use something like this for WIP. For each scenario you name you would have to do the first part of the formula: IF(CONTAINS("Object not Scenario Dependent", [Scenario Name]@row), …1 · -
Re: SUM Cells with COUNTIF Formula returning zero value
This may not work for you depending on all the other moving parts of your sheet. I tried it your way and it definitely did not like the = 0 part, but would work fine if you did a value other than 0 o…1 ·